Skip to main content

Speediful Tables

SLAM_Settings table​

The SLAM_Settings table stores configuration settings for Speediful operations. This table is automatically created during setup and contains the following key columns:

Username​

Stores the currently active Salesforce connection username. This can be set using:

EXEC dbo.SLAM_use_connection_username @username = 'your.salesforce.user@example.com'

default_exists_action​

Controls the default behavior when a destination table name is already in use by another object during query, replication, template, or metadata operations. The value is initialized to 'drop' when the SLAM procedures are first installed in a database, but can be changed to any of the following valid values:

Valid values:

  • 'drop' - Drop the existing object and create a new one (default)
  • 'rename' - Rename the existing object by appending a timestamp suffix (format: _YYYYMMDDTHHMMSS_MMM)
  • 'fail' - Throws a SQL exception if the destination object already exists

To change the default:

UPDATE SLAM_Settings
SET default_exists_action = 'rename'
note

Each stored procedure accepts an optional @exists_action parameter that overrides this default value when specified

mapping_template_columns​

Stores the column configuration for mapping templates generated by SLAM_mapping_template.

mapping_template_orderby​

Stores the sorting logic for mapping templates generated by SLAM_mapping_template.

SLAM Activity Log Table​

All operations automatically create entries in the SLAM_Activity_Log table with:

  • Operation details (type, user, organization info)
  • Performance metrics (start/end times, record counts)
  • Success/failure status
  • Options used for the operation